EMT Practice Test

1. Question Content...

---

Question1: Which of the following are standard options provided to define analytic privileges?Note: There are 3 correct answers to this question.

Question2: Why would you enable Debug Query mode in a calculation view?

Question3: You deleted the design-time file of a calculation view in your HDB module.What is the recommended way to ensure that the corresponding runtime object is also removed from the database?

Question4: You have defined a pruning configuration table in a calculation view.What are you attempting to prune from the query execution?

Question5: In a calculation view, what is the purpose of a variable?

Question6: Why would you build a calculation view of type SQL Access only?

Question7: Which are the components of SAP HANA Cloud?Note: There are 3 correct answers to this question.

Question8: In SAP Web IDE, you rename a dimension calculation view that is used by a cube calculation view. You do NOT use the option to rename the runtime view and adjust the reference. Afterward, you perform the following build operations:Build the dimension calculation view as a single object.Build the entire SAP HANA database module.What is the outcome of the build operations?

Question9: What does SAP HANA provide to support full stack native application development?Note: There are 2 correct answers to this question.

Question10: Why do you use the Hidden Columns checkbox in the semantics node of your calculation view?Note: There are 2 correct answers to this question.

Question11: You create a table function to remove historic records, sum the current total weekly working hours for each employee, and update the personnel table with the results. The deployment of the table function fails.Which of the following could be a valid reason?

Question12: What are the key steps to implement currency conversion in a calculation view?

Question13: Your calculation view consumes one data source, which includes the following columns:
SALES_ORDER_ID, PRODUCT_ID, QUANTITY and PRICE.In the output, you want to see summarized data by PRODUCT_ID and a calculated column, PRODUCT_TOTAL, with the formula QUANTITY * PRICE.In which type of node do you define the calculation to display the correct result?

Question14: You implement a referential join between Table A and Table B, but when you query the calculation view, Table B is not pruned.What could be the problem?

Note: There are 2 correct answers to this question.

Question15: Which type of join supports a temporal condition in a calculation view?

Question16: Why would you implement active / active read-enabled mode?

Question17: You set the Null Handling property for an attribute but do not set a default value.What is displayed when null values are found in a column of data type NVARCHAR?

Question18: You define a hierarchy in a calculation view. You want to expose the hierarchy to SQL Which of the following conditions must be met?Note: There are 2 correct answers to this question.

Question19: Which of the following techniques can you use to improve the performance of calculation views?Note: There are 2 correct answers to this question.

Question20: You have configured static cache for your calculation view and run a query against it, but the cache results are not being used.What might be the reason for this?

Question21: What do you use in the definition of a dynamic SQL analytic privilege?

Question22: What are some best practices for writing SQLScript for use with calculation views?Note: There are 2 correct answers to this question.

Question23: What is generated when you deploy a CUBE calculation view design-time file?Note: There are 2 correct answers to this question.

Question24: What are the consequences of NOT executing a delta merge?Note: There are 2 correct answers to this question.

Question25: Why might you use the Keep Flag property in an aggregation node?

Question26: Why does SAP issue warnings about the use of imperative or procedural SQLScript statements?

Question27: You combine two customer master data tables with a union node in a calculation view. Both master data tables include the same customer name.How do you ensure that each customer name appears only once in the results?

Question28: Why do you create calculation views of data category DIMENSION with type TIME?

Question29: Why would you partition a table in an SAP HANA Cloud database?Note: There are 2 correct answers to this question.

Question30: You want to map an input parameter of calculation view A to an input parameter of calculation view B using the parameter mapping feature in the calculation view editor. However, the input parameters of calculation view B are not proposed as source parameters.What might be the reason for this?